v0.1.98 Now Available

Need the prod schema to test a feature...
...but not the 30-minute restore?

Stop fighting for shared resources or restoring giant backups just to test code that only needs a few tables. Kopi is the developer's open source self-service tool. Just run kopi up to get an on-demand, lightweight database with the full prod schema and smart data for just the tables you need, all in seconds.

Get Started - It's Free View on GitHub →

bash — kopi-cli

Sound Familiar?

Kopi is an open-source tool built to eliminate these exact developer pain points.

Local Resource Constraints

Even if you have the local resources to restore a 500GB backup, who wants to wait 30 minutes just to test a feature?

"Tests Pass, CI Fails"

Stop mocking data. Kopi gives you the speed and isolation of mocks, but with the safety of a real database. Now you can run automated tests against the actual production schema on every commit.

Shared Server Lock

Blocked because the central dev DB is slow, down for maintenance, or locked by another team's migration.

Dirty Data Dangers

Your test user was just deleted by someone else. Your perfect debugging setup is now broken. Kopi gives you a pristine, isolated database every single time.

Workflow

Effortless by Design

Get a pristine, production-schema database in seconds with a workflow that just makes sense.

STEP 1

Define Your Slice

Create a simple kopi.json. Point to your source DB, list the tables you want to seed, and set a max row count.

kopi.json

{
    "sourceConnectionString": "Server=tcp:prod...",
    "saPassword": "Pass123!",
    "tables": [
      "Sales.SalesOrderHeader",
      "Person.Person"
    ],
    "settings": {
      "maxRowCount": 100
    }
}

Terminal

$ kopi up

STEP 2

Spin It Up

Run kopi up. In seconds, Kopi builds a fresh replica, populates *only that slice* with data, and hands you the connection string.

STEP 3

Connect & Code

Connect your application or SSMS to localhost and start building against a realistic, relationally-intact database.

Output

You can connect to your new database:
===================================
Server=localhost,1433;Database=kopi_db;User Id=sa;Password=Pass123!
===================================

Terminal

$ kopi down
Stopping container...
Removing container...
Kopi replica destroyed.

STEP 4

Tear It Down

When you're done, run kopi down to destroy the replica. Or just run kopi up again—it automatically starts fresh every time!

Read-Only Architecture

We know it's scary to point a tool at production. That's why Kopi is strictly read-only when communicating with your source database.

It issues SELECT statements to learn your schema and fetch seed data. It never writes, updates, or alters your source.

READ Source Database

SELECT * FROM INFORMATION_SCHEMA.TABLES

SELECT * FROM Sales.Orders WHERE ID IN (...)

WRITE Target (Local) Database

INSERT INTO Local.Sales.Orders...

A Workflow Superpower

A powerful, free tool for developers. A robust, secure platform for teams.

Community Edition

Free, open-source, and perfect for individual developers.

Docker-Powered Isolation: Lightweight, portable, disposable instances.

Intelligent Schema Sync: Replicates PKs, FKs, indexes, and types.

Smart Data Slicing: Generates a referentially-intact data slice.

Blazing Fast CLI: Designed for terminal-first developers.

COMING SOON

Enterprise Edition

High-value solutions for security and CI/CD stability.

Data Anonymization: Automatically scrubs PII for compliance.

Deterministic Data: Exact same data set for every CI run.

AI-Powered Realism: Context-aware data for edge-cases.

Team Configs: Shared configurations across the org.

Ready to Reclaim Your Development Time?

Stop fighting with your environment and start building. Download Kopi and experience a new level of development freedom.

Get Started with Kopi

Need the prod schema to test a feature... ...but not the 30-minute restore?